Re: Associate .jsp only
Two machines, one running apache, one running jrun. I know I can map directory paths: e.g. /www/htdocs/calendar (on Machine A) /www/calender/jsp/ (on Machine B) So when I call files from http://server.com/calender on machine A, the requests are passed to Machine B. But that would include ANY requests (including images and simple flat .html files) to be served by machine B. I only want files that end with .jsp to be passed from machine A to Machine B. The second issue was me being stupid about loading classes in CF. You can completely ignore it. -= brett At 11:32 PM 1/4/2001 -0500, you wrote: >When you say forward, you want Apache to forward .jsp requests to JRun on a separate machine, right? You have two servers with their own IP addresses? And JRun on one, but Apache and CF on the other? That should be do-able, but will require pathtrans configuration. let me know if this description fits your setup. > >Not sure what you mean in the second question. Why are you continually >stopping and starting the server? JSPs should compile every time you >request them only if you make changes to them. > >-- >Scott Stirling >West Newton, MA > >On 03 Jan 2001 07:57:39 -0800, B Schlank wrote: >> Hi! >> >> Two questions: >> >> I know you can do PATH translations, but is there a way to associate only >> the .jsp extension with jRun in a distributed environment? I want to be >> able to serve .html and .cfm files from machine "A" and only forward JSP >> requests to machine 'B'. The environment would be Apache under Linux. >> >> Also, is there anyway to force JSP compilation every single time so you >> don't have to continually stop and start the server? >> >> Any ideas? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Associate .jsp only
When you say forward, you want Apache to forward .jsp requests to JRun on a separate machine, right? You have two servers with their own IP addresses? And JRun on one, but Apache and CF on the other? That should be do-able, but will require pathtrans configuration. let me know if this description fits your setup. Not sure what you mean in the second question. Why are you continually stopping and starting the server? JSPs should compile every time you request them only if you make changes to them. -- Scott Stirling West Newton, MA On 03 Jan 2001 07:57:39 -0800, B Schlank wrote: > Hi! > > Two questions: > > I know you can do PATH translations, but is there a way to associate only > the .jsp extension with jRun in a distributed environment? I want to be > able to serve .html and .cfm files from machine "A" and only forward JSP > requests to machine 'B'. The environment would be Apache under Linux. > > Also, is there anyway to force JSP compilation every single time so you > don't have to continually stop and start the server? > > Any ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JRUN 3.0 SP1 bug found
Message acknowledged. Now shoo! Sorry, a little humor there. This isn't funny. Goddam Jikes!! Now that's funny. :-b I'll check it out at work. I'm a Linux snob at home. Did you contrive this example in a bug hunting expedition, or did this just come up naturally? :-> -- Scott Stirling West Newton, MA On 04 Jan 2001 21:17:57 +, wrote: > Hello all, I have found a little bug in JRUN 3.0 SP1. I'm running on Windows > NT4. > > Specifically, if you create a JSP page with the following content (I know, > it's not very clever to do things this way): > > <% out.print("-" + request.getParameter("whatever") == null + > ""); %> > > > It will cause an general protection fault in jikesw.exe when trying to > compile it. (So it's really a Jikes problem not strictly a JRun problem). > > It'd be great if someone from Allaire could acknowledge this message (Scott, > hello??) > > GPF details attached. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Fwd: servlet debugging]
Ah, now that makes sense! The bean would be reloadable if JRun were a little more developer-friendly, as would modified tag handler classes. But there's a lot of tricky classloader shite necessary to pull of dynamic reloading of all these things: servlets, supporting classes, tag handlers, JSPs, JavaBeans, etc. There are scope issues too, such as whether to dump the whole web-app and reload, or dump just the class at hand and reload, etc. So, JavaBeans called by JSPs are not usually reloadable. I think the current situation is that the JSP gets loaded into its own classloader, but the JavaBean gets loaded into the web-app classloader. So the workaround would be to touch a non-JSP servlet in your web-app and reload that -- which will cause all the servlets and beans in the web-app to be dumped. JSPs are loaded in their own classloader to make it eaiser for RAD with JSPs, I guess. But it should all be working dynamically in a future release (including taghandlers and JavaBeans). To be fair, I think most JSP/servlet engines have these dynamic reload problems in one area or another. Eventually we'll all get it right, I think. -- Scott Stirling West Newton, MA On 04 Jan 2001 11:17:22 -0700, Ben Groeneveld wrote: > Please let me clarify. My issue is actually with a bean my .jsp's > uses. The bean is not reloaded after I recompile it. Should it be? > Thanks, BenG. > > Original Message > Subject: servlet debugging > Date: Fri, 29 Dec 2000 10:29:17 -0700 > From: Ben Groeneveld <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > > > > What's a good way to have servlets auto-reloaded when recompiled? I > looked though the manual and this was not obvious. When I change a .jsp > jrun seems to detect that and reload, but servlets don't (I'm using the > invoker servlet shortcut). What am I missing? Currently I restart the > default jrun server to debug, but this is painfully slow. Thanks, BenG. > > > -- > Ben Groeneveld > Information Concepts, Inc., 115 N.W. Oregon, Suite 30, Bend, OR 97701 > Mailto:[EMAIL PROTECTED], phone:541.388.3611, cell:208.520.6488 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Registering EJBeans JNDI name
Are you using JDK 1.3? If not, you need the iioprt.jar file from the 1.3 JDK in your classpath. At least that's what I'm guessing is the problem. In SP2, soon to be released, we'll ship iiioprt.jar in JRun's lib/ext dir. This file has the RMI-IIOP classes in it that are needed for PortableRemoteObject.narrow(). On the other hand, it may be something else. I'll be glad to help with it. Take my advice -- stick with the ejb-jar.xml and forget the properties files. You'll notice that none of the sample clients with JRun use the PortableRemoteObject method of getting a home object. One of the samples in SP2 will though. -- Scott Stirling West Newton, MA On 04 Jan 2001 09:34:41 -0500, Usha Chintalapati wrote: > I'm having trouble understanding, which parts of the EJBean.properties file > registers the JNDI name for that bean. I followed the directions given in > samples.pdf, but they didn't work. > > I tried deploying the beans both ways, using the deployment descriptor > ejb-jar.xml and using properties files with manifest file. If anyone has > encountered similar problems and found a solution, I would really appreciate > it if you can let me know. > > TIA, > Usha > > Below are excerpts of configuration files and my code. > > Deploying using ejb-jar.xml: > - Here's how I defined a bean in this file: > > XXXHome > com.synapz.eclipz.ejb.XXXHome > com.synapz.eclipz.ejb.XXX > com.synapz.eclipz.ejb.XXXBean > Stateless > Container > > ejipt.isCreateSilent > true > > > - In my client code, I lookup this bean the following way: > void someMethod() > { > System.setProperty(Context.INITIAL_CONTEXT_FACTORY, > "allaire.ejipt.ContextFactory"); > System.setProperty(Context.PROVIDER_URL, > "ejipt://localhost:2323"); > > Context ctx = getInitialContext(); > > Object home = ctx.lookup("XXXHome"); > > XXXHome xxxHome = > (XXXHome) javax.rmi.PortableRemoteObject > .narrow(home, XXXHome.class); > } > - I do not have any problem deploying my ejb jar or my client jar. However, > when I run my client code I get the following error: > javax.naming.NameNotFoundException: UserHandlerHome not found > at allaire.ejipt._NamingContext.lookup(_NamingContext.java:73) > at allaire.ejipt._ClientContext.lookup(_ClientContext.java:113) > at javax.naming.InitialContext.lookup(InitialContext.java:350) > . ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JRUN 3.0 SP1 bug found
Hello all, I have found a little bug in JRUN 3.0 SP1. I'm running on Windows NT4. Specifically, if you create a JSP page with the following content (I know, it's not very clever to do things this way): <% out.print("-" + request.getParameter("whatever") == null + ""); %> It will cause an general protection fault in jikesw.exe when trying to compile it. (So it's really a Jikes problem not strictly a JRun problem). It'd be great if someone from Allaire could acknowledge this message (Scott, hello??) GPF details attached. <<...>> -- For more information about Barclays Capital, please visit our web site at http://www.barcap.com. Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group unless otherwise specifically stated. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
[Fwd: servlet debugging]
Please let me clarify. My issue is actually with a bean my .jsp's uses. The bean is not reloaded after I recompile it. Should it be? Thanks, BenG. Original Message Subject: servlet debugging Date: Fri, 29 Dec 2000 10:29:17 -0700 From: Ben Groeneveld <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] What's a good way to have servlets auto-reloaded when recompiled? I looked though the manual and this was not obvious. When I change a .jsp jrun seems to detect that and reload, but servlets don't (I'm using the invoker servlet shortcut). What am I missing? Currently I restart the default jrun server to debug, but this is painfully slow. Thanks, BenG. -- Ben Groeneveld Information Concepts, Inc., 115 N.W. Oregon, Suite 30, Bend, OR 97701 Mailto:[EMAIL PROTECTED], phone:541.388.3611, cell:208.520.6488 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JDBC Drivers +
No. Throwing threads at the Bridge is generally always a bad idea. ODBC drivers are not guarenteed to be thread-safe to begin with. Statements/ResultSets are considered "active" from the time they are created until they are closed; not just when you are making method calls on them. Karl. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 11:22 AM To: JRun-Talk Subject: RE: JDBC Drivers + Thanks Karl , that was my conclusion as well. The SQL IS only allowing one statements (according to getMaxactiveStatements), Access allowed 64. So I created a vector :-) This leads to another Question though, is it possible to wait using Java-Odbc until the statement is not active any more before continuing with the next getColumns statement? I even tried code like this : getColumns() while( continue ) { try { wait getColumns; continue = 0 } catch (SQLError using getColumns()) { continue = 1 ; } } .. but it just timed out all the time. I can work around it but I guess I'll like trying to figure out whats happening under the hood :-) Thanks for your help/ thoughts Justin >-Original Message- >From: Karl Moss [mailto:[EMAIL PROTECTED]] Maybe SQLServer is >doing some special statement processing/caching when using metadata that >precludes you from having multiple active statements - I just don't know >what the ODBC driver is doing under the covers. > >The generic way to program for this case is to build an >array/Vector/Collection of the table names up front, and then process the >column names for each table in a separate loop. > >Hope this helps, > >Karl. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JDBC Drivers +
Thanks Karl , that was my conclusion as well. The SQL IS only allowing one statements (according to getMaxactiveStatements), Access allowed 64. So I created a vector :-) This leads to another Question though, is it possible to wait using Java-Odbc until the statement is not active any more before continuing with the next getColumns statement? I even tried code like this : getColumns() while( continue ) { try { wait getColumns; continue = 0 } catch (SQLError using getColumns()) { continue = 1 ; } } . but it just timed out all the time. I can work around it but I guess I'll like trying to figure out whats happening under the hood :-) Thanks for your help/ thoughts Justin >-Original Message- >From: Karl Moss [mailto:[EMAIL PROTECTED]] Maybe SQLServer is >doing some special statement processing/caching when using metadata that >precludes you from having multiple active statements - I just don't know >what the ODBC driver is doing under the covers. > >The generic way to program for this case is to build an >array/Vector/Collection of the table names up front, and then process the >column names for each table in a separate loop. > >Hope this helps, > >Karl. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JDBC Drivers +
> The only thing that I can think of is that SQLServer is only allowing you > one active statement per connection when working with metadata. Here's what If you want to use more than one statement per connection you have to use a real JDBC driver. With the ODBC-bridge you can not work seriously with a DB. You have only one statement per connection and you must use the rs.getXXX functions for the attributes in the same order as they appear in the query. At least that is the state with the MS-SQL-Server. Kind regards Sven Spreier -Ursprüngliche Nachricht- Von: "Karl Moss" <[EMAIL PROTECTED]> An: "JRun-Talk" <[EMAIL PROTECTED]> Gesendet: Donnerstag, 4. Januar 2001 16:36 Betreff: RE: JDBC Drivers + > Not sure why SQLServer is being grumpy and Access works - it's usually the > other way around :) > > The only thing that I can think of is that SQLServer is only allowing you > one active statement per connection when working with metadata. Here's what > happens (working from memory here; it's been a long time since I wrote the > Bridge): when you call getTables(), a new statement handle is created, the > ODBC SQLTables function invoked (which causes the underlying ODBC driver to > issue a database query), and the result set is returned. Calling > getColumns() works in a similar way, calling SQLColumns. Maybe SQLServer is > doing some special statement processing/caching when using metadata that > precludes you from having multiple active statements - I just don't know > what the ODBC driver is doing under the covers. > > The generic way to program for this case is to build an > array/Vector/Collection of the table names up front, and then process the > column names for each table in a separate loop. > > Hope this helps, > > Karl. > > -Original Message- > From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 04, 2001 9:45 AM > To: JRun-Talk > Subject: RE: JDBC Drivers + > > > Sure : Pretty much like the following (I don't have the actual code in front > of me ): > > > DatabaseMetaData metadata = connection.getMetaData() > > String[] tableTypes = { "TABLE"}; // We want only > tables > ResultSet tables = metadata.getTables( // Get the > tables info > null, > null, > null, > tableTypes); > > String tableName; // Stores a table name > > > while(tables.next()) // For each table > { > tableName = tables.getString("TABLE_NAME"); // get the table name > System.out.println(tableName); > > //MARKER > // Get all the columns for the current table > ResultSet columnNames = metadata.getColumns(null, null, tableName, > null); > > // inner loop > while(columnNames.next()) > System.out.println("\t" + > columnNames.getString("COLUMN_NAME")); > > //MARKER_END > > } > > > > Using MDAC 2.5 + sun.jdbc.odbc.JdbcOdbcDriver on Win2000, sun SDK 1.3 works > fine with AccessdataSource > Error with SqlServer > > If I put the section between //MARKER & //MARKER_END outside the > tables.next() loop , using a tablename it works fine. > Really a Java issue and not really a JRun issues though :-) > > Thanks > > Justin > > > >-Original Message- > >From: Karl Moss [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, January 04, 2001 1:41 PM > >To: JRun-Talk > >Subject: RE: JDBC Drivers > > > > > >Can you post the offending code? > > > >Karl Moss > >Allaire Corp. > > > >-Original Message- > >From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] > >Sent: Thursday, January 04, 2001 8:36 AM > >To: JRun-Talk > >Subject: RE: JDBC Drivers > > > > > >Do these drivers support the DatabaseMetaData stuff??? > > > >On a related note can anyone tell me how the DatabaseMetaData methods > >...getTables and .getColumns return ResultSets ? > > > >I have some code that works with the Access Odbc driver , but not the SQL > >Server driver via the Odbc-bridge > > > >The code in question uses DatabaseMetaData.getTables > >to return the DB tables and loops over the ResultSet returned and retrieves > >the Columns of each table using DatabaseMetaData.getColumns() and an inner > >loop loops over the column name. > > > >However I get an ODBC error, "Database busy waiting for another hinst" > >(something like that, haven't got the exact test here) > > > >I thought that because the DatabaseMetaData.getTables() > >method had executed that the connection would be free (not using pooling). > > > >It works if I put the getColumns method outside the getTable loop. > > > >Any ideas? > > > >Thanks Justin > > > > > >>-Original Message- > >>From: Scott M. Stirling [mailto:[EMAIL PROTECTED]] > >>Sent: Thursday, January 04, 2001 6:18 AM > >>To: JRun-Talk > >>Subject: Re: JDBC Drivers > >> > >> > >>On 26 Dec 2000 11:45:22 -0500, Bob Sm
RE: JDBC Drivers +
Not sure why SQLServer is being grumpy and Access works - it's usually the other way around :) The only thing that I can think of is that SQLServer is only allowing you one active statement per connection when working with metadata. Here's what happens (working from memory here; it's been a long time since I wrote the Bridge): when you call getTables(), a new statement handle is created, the ODBC SQLTables function invoked (which causes the underlying ODBC driver to issue a database query), and the result set is returned. Calling getColumns() works in a similar way, calling SQLColumns. Maybe SQLServer is doing some special statement processing/caching when using metadata that precludes you from having multiple active statements - I just don't know what the ODBC driver is doing under the covers. The generic way to program for this case is to build an array/Vector/Collection of the table names up front, and then process the column names for each table in a separate loop. Hope this helps, Karl. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 9:45 AM To: JRun-Talk Subject: RE: JDBC Drivers + Sure : Pretty much like the following (I don't have the actual code in front of me ): DatabaseMetaData metadata = connection.getMetaData() String[] tableTypes = { "TABLE"}; // We want only tables ResultSet tables = metadata.getTables( // Get the tables info null, null, null, tableTypes); String tableName; // Stores a table name while(tables.next()) // For each table { tableName = tables.getString("TABLE_NAME"); // get the table name System.out.println(tableName); //MARKER // Get all the columns for the current table ResultSet columnNames = metadata.getColumns(null, null, tableName, null); // inner loop while(columnNames.next()) System.out.println("\t" + columnNames.getString("COLUMN_NAME")); //MARKER_END } Using MDAC 2.5 + sun.jdbc.odbc.JdbcOdbcDriver on Win2000, sun SDK 1.3 works fine with AccessdataSource Error with SqlServer If I put the section between //MARKER & //MARKER_END outside the tables.next() loop , using a tablename it works fine. Really a Java issue and not really a JRun issues though :-) Thanks Justin >-Original Message- >From: Karl Moss [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 1:41 PM >To: JRun-Talk >Subject: RE: JDBC Drivers > > >Can you post the offending code? > >Karl Moss >Allaire Corp. > >-Original Message- >From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 8:36 AM >To: JRun-Talk >Subject: RE: JDBC Drivers > > >Do these drivers support the DatabaseMetaData stuff??? > >On a related note can anyone tell me how the DatabaseMetaData methods >...getTables and .getColumns return ResultSets ? > >I have some code that works with the Access Odbc driver , but not the SQL >Server driver via the Odbc-bridge > >The code in question uses DatabaseMetaData.getTables >to return the DB tables and loops over the ResultSet returned and retrieves >the Columns of each table using DatabaseMetaData.getColumns() and an inner >loop loops over the column name. > >However I get an ODBC error, "Database busy waiting for another hinst" >(something like that, haven't got the exact test here) > >I thought that because the DatabaseMetaData.getTables() >method had executed that the connection would be free (not using pooling). > >It works if I put the getColumns method outside the getTable loop. > >Any ideas? > >Thanks Justin > > >>-Original Message- >>From: Scott M. Stirling [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, January 04, 2001 6:18 AM >>To: JRun-Talk >>Subject: Re: JDBC Drivers >> >> >>On 26 Dec 2000 11:45:22 -0500, Bob Smith wrote: >>> Hi, >>> I am new to JRUN. We are required to integrate with SQL >>Server7.0. We also >>> develop applications with ColdFusion. I was wondering if >>JRUN/Allaire has some >>> recommendations for JDBC drivers or perhaps JRUN has its own >>JDBC drivers and >>> I have missed it. >>> >>> >>> Thanks, >>> Bob >> >> >>Funny you should ask, Bob. We'll be shipping Merant Type IV JDBC >>drivers with a new JRun Advanced Edition very soon. Meanwhile, for >>development you can use the Weblogic JDBC driver for SQLServer (see >>www.bea.com) or try www.inetsoftware.de -- they have very popular, tried >>and true JDBC drivers for SQLServer. >> >>-- >>Scott Stirling >>West Newton, MA >> >> >> > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://
RE: JRun O/R Mapping
For O/R mapping, Allaire is partnering with Thoughtinc. I haven't tried it myself, but they've put a lot of work into supporting JRun and Ejipt with their CocoBase product: http://www.thoughtinc.com/allaire/index.html There are other O/R tools out there. It would be interesting if someone wanted to work with an open source project (such as jBoss/Jaws http://www.thoughtinc.com/allaire/index.html) to provide a free O/R tool for JRun. There are some other cool tools for EJB dev that would be cool to sup-"port" for JRun, such as Percolator: http://www.percolator.org/source/java/percolator/ (just ignore the alternating spellings of "percolator" on the Web site) And if you haven't seen EJBDoclet yet, it's definitely worth a look; it's free and open source and you can code gen all your EJB interfaces, objects and ejb-jar.xml from a single file using special Javadoc tags: http://sourceforge.net/projects/ejbdoclet/ Scott Stirling Allaire Corporation http://www.allaire.com/developer/jrunreferencedesk/ > -Original Message- > From: Damon Kuntz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 04, 2001 9:00 AM > To: JRun-Talk > Subject: JRun O/R Mapping > > > Is there any good documentation available on CMP O/R mapping > in JRun 3.0? I > don't find the packaged examples from allaire to be very helpful. > > Any suggestions would be greatly appreciated. > > Damon Kuntz ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JDBC Drivers +
Sure : Pretty much like the following (I don't have the actual code in front of me ): DatabaseMetaData metadata = connection.getMetaData() String[] tableTypes = { "TABLE"}; // We want only tables ResultSet tables = metadata.getTables( // Get the tables info null, null, null, tableTypes); String tableName; // Stores a table name while(tables.next()) // For each table { tableName = tables.getString("TABLE_NAME"); // get the table name System.out.println(tableName); //MARKER // Get all the columns for the current table ResultSet columnNames = metadata.getColumns(null, null, tableName, null); // inner loop while(columnNames.next()) System.out.println("\t" + columnNames.getString("COLUMN_NAME")); //MARKER_END } Using MDAC 2.5 + sun.jdbc.odbc.JdbcOdbcDriver on Win2000, sun SDK 1.3 works fine with AccessdataSource Error with SqlServer If I put the section between //MARKER & //MARKER_END outside the tables.next() loop , using a tablename it works fine. Really a Java issue and not really a JRun issues though :-) Thanks Justin >-Original Message- >From: Karl Moss [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 1:41 PM >To: JRun-Talk >Subject: RE: JDBC Drivers > > >Can you post the offending code? > >Karl Moss >Allaire Corp. > >-Original Message- >From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 8:36 AM >To: JRun-Talk >Subject: RE: JDBC Drivers > > >Do these drivers support the DatabaseMetaData stuff??? > >On a related note can anyone tell me how the DatabaseMetaData methods >...getTables and .getColumns return ResultSets ? > >I have some code that works with the Access Odbc driver , but not the SQL >Server driver via the Odbc-bridge > >The code in question uses DatabaseMetaData.getTables >to return the DB tables and loops over the ResultSet returned and retrieves >the Columns of each table using DatabaseMetaData.getColumns() and an inner >loop loops over the column name. > >However I get an ODBC error, "Database busy waiting for another hinst" >(something like that, haven't got the exact test here) > >I thought that because the DatabaseMetaData.getTables() >method had executed that the connection would be free (not using pooling). > >It works if I put the getColumns method outside the getTable loop. > >Any ideas? > >Thanks Justin > > >>-Original Message- >>From: Scott M. Stirling [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, January 04, 2001 6:18 AM >>To: JRun-Talk >>Subject: Re: JDBC Drivers >> >> >>On 26 Dec 2000 11:45:22 -0500, Bob Smith wrote: >>> Hi, >>> I am new to JRUN. We are required to integrate with SQL >>Server7.0. We also >>> develop applications with ColdFusion. I was wondering if >>JRUN/Allaire has some >>> recommendations for JDBC drivers or perhaps JRUN has its own >>JDBC drivers and >>> I have missed it. >>> >>> >>> Thanks, >>> Bob >> >> >>Funny you should ask, Bob. We'll be shipping Merant Type IV JDBC >>drivers with a new JRun Advanced Edition very soon. Meanwhile, for >>development you can use the Weblogic JDBC driver for SQLServer (see >>www.bea.com) or try www.inetsoftware.de -- they have very popular, tried >>and true JDBC drivers for SQLServer. >> >>-- >>Scott Stirling >>West Newton, MA >> >> >> > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Registering EJBeans JNDI name
I'm having trouble understanding, which parts of the EJBean.properties file registers the JNDI name for that bean. I followed the directions given in samples.pdf, but they didn't work. I tried deploying the beans both ways, using the deployment descriptor ejb-jar.xml and using properties files with manifest file. If anyone has encountered similar problems and found a solution, I would really appreciate it if you can let me know. TIA, Usha Below are excerpts of configuration files and my code. Deploying using ejb-jar.xml: - Here's how I defined a bean in this file: XXXHome com.synapz.eclipz.ejb.XXXHome com.synapz.eclipz.ejb.XXX com.synapz.eclipz.ejb.XXXBean Stateless Container ejipt.isCreateSilent true - In my client code, I lookup this bean the following way: void someMethod() { System.setProperty(Context.INITIAL_CONTEXT_FACTORY, "allaire.ejipt.ContextFactory"); System.setProperty(Context.PROVIDER_URL, "ejipt://localhost:2323"); Context ctx = getInitialContext(); Object home = ctx.lookup("XXXHome"); XXXHome xxxHome = (XXXHome) javax.rmi.PortableRemoteObject .narrow(home, XXXHome.class); } - I do not have any problem deploying my ejb jar or my client jar. However, when I run my client code I get the following error: javax.naming.NameNotFoundException: UserHandlerHome not found at allaire.ejipt._NamingContext.lookup(_NamingContext.java:73) at allaire.ejipt._ClientContext.lookup(_ClientContext.java:113) at javax.naming.InitialContext.lookup(InitialContext.java:350) . Deploying using properties and manifest file: - Here's how my bean.properties file looks: ejb.beanHomeName=XXXHome ejb.homeInterfaceClassName=com.synapz.eclipz.ejb.XXXHome ejb.remoteInterfaceClassName=com.synapz.eclipz.ejb.XXX ejb.enterpriseBeanClassName=com.synapz.eclipz.ejb.XXXBean ejb.stateManagementType=stateless_session ejb.allowedIdentities=all ejb.runAsMode=system_identity ejb.sessionTimeout=300 ejipt.env_entries=updateInterval - the contents of mainifest file are: Name: com/synapz/eclipz/ejb/UserHandler.properties Enterprise-Bean: True - Again I do not have any problem deploying my ejb jar or my client jar. Now, when I run my client code I get the following error: javax.naming.NamingException: Failed to unmarshal proxy. Root exception is java.lang.ClassNotFoundException: com.synapz.eclipz.ejb.XXXHomeObject_Stub (no security manager: RMI class loader disabled) at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:318) at sun.rmi.server.LoaderHandler.loadClass(LoaderHandler.java:132) at sun.rmi.server.MarshalInputStream.resolveClass(MarshalInputStream.java:143) at java.io.ObjectInputStream.inputClassDescriptor(ObjectInputStream.java:918) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:366) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:236) at java.io.ObjectInputStream.inputObject(ObjectInputStream.java:1186) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:386) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:236) at java.rmi.MarshalledObject.get(MarshalledObject.java:138) at allaire.ejipt._NamingContext$_Proxy._resolve(_NamingContext.java:362) at allaire.ejipt._NamingContext.lookup(_NamingContext.java:68) at allaire.ejipt._ClientContext.lookup(_ClientContext.java:113) at javax.naming.InitialContext.lookup(InitialContext.java:350) . ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
JRun O/R Mapping
Is there any good documentation available on CMP O/R mapping in JRun 3.0? I don't find the packaged examples from allaire to be very helpful. Any suggestions would be greatly appreciated. Damon Kuntz ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JDBC Drivers
Can you post the offending code? Karl Moss Allaire Corp. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 8:36 AM To: JRun-Talk Subject: RE: JDBC Drivers Do these drivers support the DatabaseMetaData stuff??? On a related note can anyone tell me how the DatabaseMetaData methods ...getTables and .getColumns return ResultSets ? I have some code that works with the Access Odbc driver , but not the SQL Server driver via the Odbc-bridge The code in question uses DatabaseMetaData.getTables to return the DB tables and loops over the ResultSet returned and retrieves the Columns of each table using DatabaseMetaData.getColumns() and an inner loop loops over the column name. However I get an ODBC error, "Database busy waiting for another hinst" (something like that, haven't got the exact test here) I thought that because the DatabaseMetaData.getTables() method had executed that the connection would be free (not using pooling). It works if I put the getColumns method outside the getTable loop. Any ideas? Thanks Justin >-Original Message- >From: Scott M. Stirling [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 6:18 AM >To: JRun-Talk >Subject: Re: JDBC Drivers > > >On 26 Dec 2000 11:45:22 -0500, Bob Smith wrote: >> Hi, >> I am new to JRUN. We are required to integrate with SQL >Server7.0. We also >> develop applications with ColdFusion. I was wondering if >JRUN/Allaire has some >> recommendations for JDBC drivers or perhaps JRUN has its own >JDBC drivers and >> I have missed it. >> >> >> Thanks, >> Bob > > >Funny you should ask, Bob. We'll be shipping Merant Type IV JDBC >drivers with a new JRun Advanced Edition very soon. Meanwhile, for >development you can use the Weblogic JDBC driver for SQLServer (see >www.bea.com) or try www.inetsoftware.de -- they have very popular, tried >and true JDBC drivers for SQLServer. > >-- >Scott Stirling >West Newton, MA > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JDBC Drivers
Do these drivers support the DatabaseMetaData stuff??? On a related note can anyone tell me how the DatabaseMetaData methods ..getTables and .getColumns return ResultSets ? I have some code that works with the Access Odbc driver , but not the SQL Server driver via the Odbc-bridge The code in question uses DatabaseMetaData.getTables to return the DB tables and loops over the ResultSet returned and retrieves the Columns of each table using DatabaseMetaData.getColumns() and an inner loop loops over the column name. However I get an ODBC error, "Database busy waiting for another hinst" (something like that, haven't got the exact test here) I thought that because the DatabaseMetaData.getTables() method had executed that the connection would be free (not using pooling). It works if I put the getColumns method outside the getTable loop. Any ideas? Thanks Justin >-Original Message- >From: Scott M. Stirling [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 04, 2001 6:18 AM >To: JRun-Talk >Subject: Re: JDBC Drivers > > >On 26 Dec 2000 11:45:22 -0500, Bob Smith wrote: >> Hi, >> I am new to JRUN. We are required to integrate with SQL >Server7.0. We also >> develop applications with ColdFusion. I was wondering if >JRUN/Allaire has some >> recommendations for JDBC drivers or perhaps JRUN has its own >JDBC drivers and >> I have missed it. >> >> >> Thanks, >> Bob > > >Funny you should ask, Bob. We'll be shipping Merant Type IV JDBC >drivers with a new JRun Advanced Edition very soon. Meanwhile, for >development you can use the Weblogic JDBC driver for SQLServer (see >www.bea.com) or try www.inetsoftware.de -- they have very popular, tried >and true JDBC drivers for SQLServer. > >-- >Scott Stirling >West Newton, MA > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A New Instance of the Server
See the bottom of pg. 90, in the JRun Setup Guide for all the details on how to do this. Good luck. Skip -Original Message- From: Sasha Ivankoff (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 6:55 AM To: JRun-Talk Subject: A New Instance of the Server Hello everyone, there is a short question, how to make a new instance of the server. Thank you, Alexander Ivankoff Alexander Ivankoff Senior Programmer Analyst ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: jrun2.3 NT model
Daniel, it sounds to me as if you are confusing an "outbound" HTTP proxy service with a JRun "connector proxy". These are two very different beasts. The JCP (JRun Connector Proxy) is a JRun service that enables a web server (IIS of Netscape) to talk to JRun, usually via an ISAPI or NSAPI plugin, but possibly via a CGI or even from another servlet... note that the "web server" is actually the connection "client" from a network perspective in this converstation. The web browser is a client of the web server, the web server is, in turn, a client of the JRun service. An HTTP proxy is normally used to allow browsers sitting on a private network to access internet based web sites. A proxy in this configuration is not used to deliver an internal web site to internet based clients. Normally, with such a configuration, internal browsers are "clients" of the proxy server, that, in turn, becomes a client of the externally hosted web site. The fact that you mention a port number like leads me to believe you are attempting to use such an HTTP proxy. An HTTP proxy can not talk directly to a JCP, they do not even speak ths same applicaiton layer protocol. Why are you using an HTTP proxy at all? Why not place a web server on the Internet and use the web server plugin supplied by JRun to access the internal JRun service? This is the "normal" configuration. It is possible to set up an HTTP proxy server as a "reverse proxy" and use it as such to permit external browsers to see an internally hosted web site... but this is probably overkill for your needs. Doing so, you would still need an internal web server to be proxied (not the JRun JCP) Ed. > -Original Message- > From: daniel garcia [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 03, 2001 9:31 AM > To: JRun-Talk > Subject: Re: jrun2.3 NT model. > > > Hello. > > Just beginning to learn howto use jrun2.3 while learning java servlets. It > worked perfectly well when I was developing in Win98. But when I started > deploying to a proxy server [using WinNT and IIS4.0], I couldn't make the > thing visible on the internet. Locally, however, people can see it- output > of the servlets. > > > > The proxy port number is . For the port number entry box in Jrun > Connection wizard, we tried , 8080, etc. Nothng seems to work. > Locally, > it does. > > > > What seems to be the problem? Can anyone help me. Any help would be > appreciated. > > > > Best wishes, > > > > Danny > * DISCLAIMER: The information contained in this e-mail may be confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
A New Instance of the Server
Hello everyone, there is a short question, how to make a new instance of the server. Thank you, Alexander Ivankoff Alexander Ivankoff Senior Programmer Analyst DoD High Performance Computing Modernization Office/User Technology Associates Group, Tel: 703-812-8205 Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists