mihir maniar

I would like to insert 3 records, 1 records each in 3 different tables to complete a transaction in IBATIS. I need to repeat this for about 3 to 4 lac records. So while using the SQLMAPExecutor object , while putting a different in this object resulted in taking a long time to insert 5000 records where as if I put only one insert query (i.e. inserting to one table only) then it would hardly 2 seconds to do the same. So please help me with this, since the transaction spans across 2 tables, i need to do that at once and then repeat the same for the other records. Thanks in advance.

I get the following error "javax.naming.NamingException: Cannot create resource instance" at the line "DataSource ds = (DataSource)envContext.lookup("jdbc/mydb");" in my action class.

I am trying to connect to MySQL database using JNDI. the document that I am referring to resolve the issue is: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

the configuration of the system is: Tomcat 5.5.12 Struts 1.3 MySQL Server version: 5.0.37-community-nt MySQL Community Edition (GPL) MYSQL connector to connect frm java code mysql-connector-java-5.0.8-bin.jar (I have downloaded the connector from http://dev.mysql.com/downloads/connector/j/5.0.html ) The code to connect in the action class is

Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/mydb"); Connection conn = ds.getConnection();

The complete error stack is
javax.naming.NamingException: Cannot create resource instance at org.apache.naming.factory.ResourceEnvFactory.getObjectInstance(ResourceEnvFactory.java:99) at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source) at org.apache.naming.NamingContext.lookup(NamingContext.java:792) at org.apache.naming.NamingContext.lookup(NamingContext.java:139) at org.apache.naming.NamingContext.lookup(NamingContext.java:780) at org.apache.naming.NamingContext.lookup(NamingContext.java:152) at com.polaris.LoginAction.execute(LoginAction.java:32) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source)

This is my server.xml

<Server port="8005" shutdown="SHUTDOWN"> <!-- Comment these entries out to disable JMX MBeans support used for the administration web application --> <Listener className="org.apache.catalina.core.AprLifecycleListener" /> <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" /> <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /> <Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/> <!-- Global JNDI resources --> <GlobalNamingResources> <!-- Test entry for demonstration purposes --> <Environment name="simpleValue" type="java.lang.Integer" value="30"/> <!-- Editable user database that can also be used by UserDatabaseRealm to authenticate users --> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" pathname="conf/tomcat-users.xml" /> </GlobalNamingResources> <Service name="Catalina"> <Connector port="8080" maxHttpHeaderSize="8192" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" redirectPort="8443" acceptCount="100" connectionTimeout="20000" disableUploadTimeout="true" /> <Connector port="8009" enableLookups="false" redirectPort="8443" protocol="AJP/1.3" /> <Engine name="Catalina" defaultHost="localhost"> <Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase"/> <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false"> <Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="system" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/mysql?autoReconnect=true"/> </Host> </Engine> </Service> </Server>


This is the web.xml


<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee <a href="http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"" target="_blank" rel="nofollow">http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"</a> version="2.4"> <description>MySQL Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/mydb</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> <servlet> <servlet-name>action</servlet-name> <servlet-class>org.apache.struts.action.ActionServlet</servlet-class> <init-param> <param-name>config</param-name> <param-value>/WEB-INF/struts-config.xml</param-value> </init-param> <init-param> <param-name>config/BMS</param-name> <param-value>/WEB-INF/struts-BMS-config.xml</param-value> </init-param> <init-param> <param-name>debug</param-name> <param-value>2</param-value> </init-param> <init-param> <param-name>detail</param-name> <param-value>2</param-value> </init-param> <load-on-startup>2</load-on-startup> </servlet> <servlet-mapping> <servlet-name>action</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> </web-app>

Kindly let me know what is going wrong. Thanks a million in advance.

well one of the better programming model would be to have a servlet that will call the DAO objects that talk to database and retrieve the values that you want in a POJO (Plain old java object). then store this in the session and call the jsp and from session access this object. i hope this helps you.

Hi,
i have developed a code for Nokia 6600 to talk to Computer. the only thing where it get's stuck is the UUID stuff. i am not sure what value to specify in for the UUID and the attribute set while opening the connection to the computer via the Nokia 6600 code.
public void connect(String s)throws IOException { String UUID = new UUID("1101",false).toString();//1101 00112233445566778899AABBCCDDEEFF System.out.println("UUID is....."+UUID); int discoveryMode = DiscoveryAgent.GIAC; LocalDevice device = null; // no paring needed try { device = LocalDevice.getLocalDevice(); device.setDiscoverable(DiscoveryAgent.GIAC); String url = "btspp://localhost:" + UUID + ";name=PCServerCOMM"; System.out.println("URL is....."+url); synchronized (this) { notifier = (StreamConnectionNotifier) Connector.open(url); servRecord = device.getRecord(notifier); System.out.println("SERVRECORD is....."+servRecord); StreamConnection conn= notifier.acceptAndOpen(); DataOutputStream out = conn.openDataOutputStream(); out.writeUTF(s); /*LocalDevice local = LocalDevice.getLocalDevice(); DiscoveryAgent agent = local.getDiscoveryAgent(); String connString = agent.selectService( new UUID("1101", false), ServiceRecord.NOAUTHENTICATE_NOENCRYPT, false); */ /*try { // Connect to the server and send 'Hello, World' /* StreamConnection conn = (StreamConnection) Connector.open(connString); OutputStream out = conn.openOutputStream(); out.write("Hello, World".getBytes()); out.close(); conn.close(); System.out.println("Message sent correctly"); } catch (IOException e) { System.out.println("IOException: "); System.out.println(e.getMessage()); } */ } } catch(IOException e) { System.out.println("IOException"); } catch(Exception e) { System.out.println("exception of url"); e.printStackTrace(); } } }

this is the code on the computer so that the mobile can communicate.
in the constructor of my class.

System.out.println("Entering Client constructor"); localDevice = LocalDevice.getLocalDevice(); discoveryAgent = localDevice.getDiscoveryAgent(); //System.out.println(localDevice.getRecord().getConnectionURL(ServiceRecord.NOAUTHENTICATE_NOENCRYPT,true)); device = new RemoteDevice[10]; // Starts inquiry for devices in the proximity and waits till the //inquiry is completed. System.out.println("\nSearching for Devices...\n"); discoveryAgent.startInquiry(DiscoveryAgent.GIAC,this); synchronized(this){ this.wait(); } //Once the Device inquiry is completed it starts searching for the //required service. service search is done with the given uuid. //After starting each search it waits for the result. If the //connectionURL is null, ie, if No service Records obtained, then //it continues search in the next device detected. // server 86b4d249fb8844d6a756ec265dd1f6a3 // client 86b4d249fb8844d6a756ec265dd1f6a3 String UUID = new UUID("0003",false).toString();//1101 00112233445566778899AABBCCDDEEFF System.out.println("UUID is....."+UUID); String url = "btspp://localhost:" + UUID + ";name=PCServerCOMM"; int[] attrSet = null; UUID[] uuids = new UUID[1]; //uuids[0] = new UUID("0003",false); //Vid 1001 and Pid 1131. //for(int i = 0; i< count;i++) { System.out.println("Starting to search services..."); //int transactionid = discoveryAgent.searchServices(attrSet,uuids,device[i],this); //System.out.println("Starting to search services transaction id..."+transactionid); //if(transactionid != -1){ /*StreamConnection connection = getconnection(); op = connection.openOutputStream(); ip = connection.openInputStream(); readData();*/ notifier = (StreamConnectionNotifier) Connector.open(url); //servRecord = localDevice.getRecord(notifier); //System.out.println("SERVRECORD is....."+servRecord); StreamConnection conn= notifier.acceptAndOpen(); DataInputStream in = conn.openDataInputStream(); in.readUTF(); synchronized(this){ System.out.println("Starting to wait after searching the service.."); this.wait(); }

yOU can clearly see that i've tried lot of stuff. pls help at the earliest. thanks a million.

I have a client.jsp on server A. I want to call server.jsp on B server with required parameters, from client.jsp and then come back to client.jsp with the some of the input controls present on the server.jsp page. how to go about it. thanks in advance.
[ December 25, 2006: Message edited by: Bear Bibeault ]

this is my command.
<target name="war" depends="mycreate">
<!--Create the war file now since the folder is ready-->
<war update="true" destfile="${MyApp.name}.war" basedir = "${createFolder}" >
</war>
</target>

i am getting an error :
"BUILD FAILED
C:\Mihir\Ant\CreateJar\build.xml:67: webxml attribute is required"

i am using ant 1.6.5.
i have written a command previously that copies the web.xml into the folder which will be converted to war using the above command.
<copy toDir="${createFolder}/${createWebInf}" overwrite="true">
<fileset dir=".">
<include name="web.xml"/>
</fileset>
</copy>

I would like to know how to start or stop the tomcat 5.0 and wsad 1.3 servers using the ant script. Thanks in advance.

thank you for your suggestion Mr Clapham. I would like to know the exact syntax of the "java -jar " solution. secondly there must be a easier way to deploy this code on the client side without having the client to do all this. please suggest some other way if possible. the other machine that i was referring to is that of client.

thank you for all the solutions . i worked it out and it is fine. i have put a jar file in the startup folder and restarted windows and java code runs without the comman prompt but the problem is that if i close that window then how should i re invoke the application? i.e. how to re invoke the application from a jar file?

this thing is working fine on my machine but on another machine it opens the winrar when the machine starts. this is because in the " open with " property of this jar file winrar program is chosen to open it. i tried to change it to javaw option but no such exe is listed there on another machine. that machine has jre installed and it is the same version as on my machine then what could be the problem. if on that machine when i place the entire path of the jar file in the classpath then it works fine.what is wrong.

how to ensure that only one instance of that application is running in that case? i mean to say when i click on the jar file in the start menu it will start a new application. i want to start only one instance of this application. how to achieve that?

thank you for all the solutions . i worked it out and it is fine. i have put a jar file in the startup folder and restarted windows and java code runs without the comman prompt but the problem is that if i close that window then how should i re invoke the application? i.e. how to re invoke the application from a jar file?

1.> it works on my machine but not on other machine. it says that there is some error and that command prompt window just goes away. but if i call the batch file seperately, then it works fine.
2.> it is ok for developers machine but if the same has to be deployed on the client's machine then the command prompt window looks ugly and annoying. how to solve this one?

I would like to run a standalone java code when the operating system loads all by itself just like any other services. i hope the question is clear enough. any kind of help is appreciated. thanks in advance

when i try the following code it tells me unparseable date "01022006". could you pls help me the exact area where it is causing the problem and help me rectify it. thx.

String strDate=new String("01052006");
Date d = DateFormat.getDateInstance().parse(strDate);
out.println(d.toString());

i have a string in the format "01022006" which should get converted to date object and give me the date as 02-01-2006. i.e. 2nd Jan 2006. How can i achieve this?