Sign Up ›
  • Aju
  • NEWBIE
  • 0 Points
  • Member since 2006
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 5
    Replies
6 replies

Unable to "Deploy trigger using Force.com IDE"

Hi all,

I might be sounding childish but..it is

Iam trying to deploy a trigger from sandbox onto production instance using Force.com IDE.

When i select the project ->Force.com IDE-> i donot see any option to deploy the trigger on production

Iam using eclipse 3.2 and respective Force.com IDE.

Pls help

Thanks
Kumar
8 replies

Oracle to SFDC: Using command Line Data Loader

Iam trying to export data from Oracle to SFDC using Command Line .

Iam finding the below error.

ERROR [testProcess] database.DatabaseContext initConnection (DatabaseContext.java:94) - Database error encountered during connecting for database configuration: queryAccount.  Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)

PLease find the entire error log,process-conf,database-conf as below.

Your help is highly appreciated.

2007-08-29 09:56:40,722 INFO  [main] controller.Controller initLog (Controller.java:382) - The log has been initialized
2007-08-29 09:56:40,722 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: c:\test\process-conf.xml
2007-08-29 09:56:40,784 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [c:\test_hms\process-conf.xml]
2007-08-29 09:56:40,816 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available
2007-08-29 09:56:40,816 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available
2007-08-29 09:56:40,878 INFO  [testProcess] controller.Controller initConfig (Controller.java:343) - The controller config has been initialized
2007-08-29 09:56:40,894 INFO  [testProcess] process.ProcessRunner run (ProcessRunner.java:102) - Initializing process engine
2007-08-29 09:56:40,894 INFO  [testProcess] process.ProcessRunner run (ProcessRunner.java:105) - Loading parameters
2007-08-29 09:56:41,942 INFO  [testProcess] process.ProcessRunner run (ProcessRunner.java:116) - Logging in to: https://www.salesforce.com
2007-08-29 09:56:42,741 INFO  [testProcess] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: queryAccount of type: databaseRead
2007-08-29 09:56:42,741 INFO  [testProcess] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [c:\test_hms\database-conf.xml]
2007-08-29 09:56:42,834 INFO  [testProcess] process.ProcessRunner run (ProcessRunner.java:121) - Checking the data access object connection
2007-08-29 09:56:45,354 ERROR [testProcess] database.DatabaseContext initConnection (DatabaseContext.java:94) - Database error encountered during connecting for database configuration: queryAccount.  Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection(DatabaseContext.java:87)
    at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnection(DatabaseContext.java:79)
    at com.salesforce.lexiloader.dao.database.DatabaseReader.checkConnection(DatabaseReader.java:231)
    at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.java:123)
    at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.java:230)
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
    ... 6 more
2007-08-29 09:56:45,354 FATAL [testProcess] process.ProcessRunner run (ProcessRunner.java:155) - Database error encountered during connecting for database configuration: queryAccount.  Sql error: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection).


process-conf.xml
==========
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="testProcess" class="com.salesforce.lexiloader.process.ProcessRunner" singleton="false">
        <description>test from database</description>
        <property name="name" value="testProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="a@gmail.com"/>
                <entry key="sfdc.password" value="xxxx"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="insert"/>
                <entry key="process.mappingFile" value="C:\testmap.sdl"/>
                <entry key="dataAccess.name" value="queryAccount"/>
                <entry key="dataAccess.type" value="databaseRead"/>
                </map>
        </property>
    </bean>


database-conf.xml
============
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>

<bean id="queryAccount"
      class="com.salesforce.lexiloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryAccountSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>

<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@my.server.com:1521:orcl"/>
    <property name="username" value="scott"/>
    <property name="password" value="tiger"/>
</bean>



<bean id="queryAccountSql"
      class="com.salesforce.lexiloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            SELECT c1,c2
            FROM test
            </value>
    </property>
    <property name="columnNames">
        <list>
            <value>c1</value>
            <value>c2</value>
            </list>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="process.lastRunDate" value="java.sql.Timestamp"/>
        </map>
    </property>
</bean>

</beans>


Thanks a lot in advance
Ajay

5 replies

Where and how to define the username and password, if we r running from command line

I am trying to run from command line, so i defined bt config.properties file as follow,
 
#Loader Config
#Thu Jun 15 17:39:34 PDT 2006
sfdc.endpoint=https\://www.salesforce.com
sfdc.proxyHost=10.236.145.251
sfdc.proxyPort=8888
sfdc.username=shreemganesh@rediffmail.com
sfdc.password=
sfdc.process=C:\Program Files\salesforce.com\AppExchange Data Loader 8.0\samples\conf\process-conf.xml
sfdc.database=C:\Program Files\salesforce.com\AppExchange Data Loader 8.0\samples\conf\database-conf.xml
 
now for "sfdc.password" whether i have to give actual password or the encrypt value of the actual password or else where to define the username and password
 
my process.config file will be like following,
 
@echo off
if not [%1]==[] goto run
echo.
echo Usage: process ^<configuration directory^> ^[process name^]
echo.
echo      configuration directory -- directory that contains configuration files,
echo          i.e. config.properties, process-conf.xml, database-conf.xml
echo.
echo      process name -- optional name of a batch process bean in process-conf.xml,
echo          for example:
echo.
echo              process ../myconfigdir AccountInsert
echo.
echo          If process name is not specified, the parameter values from config.properties
echo          will be used to run the process instead of process-conf.xml,
echo          for example:
echo.
echo              process ../myconfigdir
echo.
goto end
:run
set PROCESS_OPTION=
if not [%2]==[] set PROCESS_OPTION=process.name=%2
..\_jvm\bin\java.exe -cp ..\AppExchangeDataLoader.jar -Dsalesforce.config.dir=%1 com.salesforce.lexiloader.process.ProcessRunner %PROCESS_OPTION%
java -Xms256m -Xmx256m -Dsalesforce.config.dir=C:\Program Files\salesforce.com\AppExchange Data Loader 8.0\conf –jar AppExchangeDataLoader.jar

:end
 
so from the command prompt, i am calling as,
 
C:\Program Files\salesforce.com\AppExchange Data Loader 8.0\bin>process ../conf
 
Please help to resolve this issue