RE: How do I create a news app user?
Thanks, that did the trick. I had been playing with the principles.xml file in the actual /news directory and didn't seem to have any luck. Alex --On Friday, August 18, 2000 11:45 AM +0200 Frank Eggink [EMAIL PROTECTED] wrote: Alex, Have a look in the principals.xml file in the config directory. If you remove the 'deactivated=true' properties for admin and user, you will be able to log in using either one of them. Cheers, Frank On Friday, August 18, 2000 9:04 AM, Alex Johnson [SMTP:[EMAIL PROTECTED]] wrote: Hi All... Could someone please tell me how to create a user who can log into the news application demo? Thanks Alex
hsql datasource - can't make it work
Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Re: hsql datasource - can't make it work
Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Re: hsql datasource - can't make it work
Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) ------- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. ------- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Re: hsql datasource - can't make it work
Thanks Richard. That did it. It wanted: org.hsql.jdbcDriver I appreiate your help very much. Orion team, if your reading, do you think you could correct your docs/FAQ? Alex --On Friday, August 18, 2000 10:57 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: I just re-examined the contents of the jar file, and the class you are after is in org/hsql/jdbcDriver.class So try changing the driver line to "org.hsql.jdbcDriver" if that does not work, try org.hsql.Driver I will have a closer look when i am home from work in about 4 or 5 hours. Richard. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: tatus: RO X-Status: X-Keywords: X-UID: 394 Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) ------- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. ------- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex