Saving Code (not publishing): How?
Locked
12
12
 
|
James,
John McKeon suggested using a different database for the repository. I took hissuggestion to go away from the defaul sqlite and use a Postgresql database as a respository (I thought this might be less desireable and also didn't want whatever was causing the sqlite issue to cause other issues down the line if I didn't solve it). It works! I can actually start working in Smalltalk! On Apr 11, 10:38 am, James Robertson <[hidden email]> wrote: > well, you could fire up vwnc, and load the SQLlite driver, and see if it works > > On Apr 11, 2010, at 10:51 AM, Hunter wrote: > > > > > Just tried that and shutdown Webvelocity, relaunched Webvelocity, > > defined database, mapped some classes - tried to publish: same error. > > Seems sqlite isn't installed properly. Is there a way to test that > > independent of Webvelocity? > > > On Apr 11, 1:10 am, James Robertson <[hidden email]> wrote: > >> try putting it into Windows\system32 > > >> On Apr 10, 2010, at 11:18 PM, Hunter wrote: > > >>> Still working on this issue. I suspect it is related to possibly not > >>> finding sqlite. When I attempt to publish, the following error is > >>> displayed: > >>> ‘There is no connection a database’ > >>> OS: > >>> Microsoft Windows Vista Home Premium Edition (x86 64-bit) Service Pack > >>> 1 > >>> Database Configuration: > >>> Platform: PostgreSQL > >>> Mappings: Schema1 > >>> Host: localhost > >>> Port: 5432 > >>> Database: SICTEST > >>> Schema: public > >>> Username: postgres > >>> Repository: > >>> Name: Personal > >>> Platform: SQLite 3 > >>> Database: personal.db > > >>> The only sqlite dll I could find was on my backup drive, so I copied > >>> that file (sqlite3.dll 254 KB dated May 14, 2009, 6:04:00 AM ) > >>> to C:\Program Files (x86)\Common Files. I added this to the path - > >>> still no luck. Suggestions? > > >>> On Mar 29, 12:26 am, "Mark D. Roberts" <[hidden email]> wrote: > >>>> On 3/29/2010 1:05 PM, Hunter wrote: > > >>>>> I'm just trying > >>>>> 'save' my code (methods, classes, etc), but get the 'There is no > >>>>> connection to a database' error and the suggestions I've received so > >>>>> far don't seem to foot to something I can do specifically. I've > >>>>> createda PostgreSQL database, complete with data. Supposedly my > >>>>> database configuration works, the 'test login' works. Then I generated > >>>>> (map) just a few classes. I want to save this, and future work too. My > >>>>> exact steps are: 'Open Browser', click on my loaded application > >>>>> 'ShawInvestmentCompany', select Actions\Publish, click OK. Form this I > >>>>> receive 'There is no connection a database'. > > >>>> Maybe you've already checked this over, but just to make sure... > > >>>> When you open the "Repositories" menu on the main page, what's selected? > >>>> "Personal"? When you select "edit" for the currently selected > >>>> repository, what are the connection settings in the "Edit Repository" > >>>> dialog? > > >>>> In WebVelocity 1.0, the code for your application and its data are > >>>> stored in distinct databases. The application code that you publish goes > >>>> into a repository, and this is set using the "Repositories" menu on the > >>>> main page. By default, WebVelocity uses a SQLite database called > >>>> "Personal", and this should just be configured and ready to go when you > >>>> launch. That is, SQLite is bundled with WebVelocity and no manual > >>>> configuration is necessary, unless you want to save your code in a > >>>> different repository. If you changed this setting to a different > >>>> database, or the configuration is messed up somehow, then you may need > >>>> to change it back. You can also create new code repositories using the > >>>> "New" menu. > > >>>> Your application data, on the other hand, goes into a separate database > >>>> that is configured from the "Database" menu in the Application Editor. > >>>> It sounds like you have that configured correctly for your application, > >>>> but perhaps somewhere along the line the repository that you have > >>>> selected for code storage got confused somehow. > > >>>> So, I'd say double check that first. > > >>>> Regards, > > >>>> M. Roberts > >>>> Cincom Systems, Inc. > > >>> -- > >>> You received this message because you are subscribed to the Google Groups "WebVelocity" group. > >>> To post to this group, send email to [hidden email]. > >>> To unsubscribe from this group, send email to [hidden email]. > >>> For more options, visit this group athttp://groups.google.com/group/webvelocity?hl=en.-Hide quoted text - > > >> - Show quoted text - > > > -- > > You received this message because you are subscribed to the Google Groups "WebVelocity" group. > > To post to this group, send email to [hidden email]. > > To unsubscribe from this group, send email to [hidden email]. > > For more options, visit this group athttp://groups.google.com/group/webvelocity?hl=en.- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "WebVelocity" group. To post to this group, send email to [hidden email]. To unsubscribe from this group, send email to [hidden email]. For more options, visit this group at http://groups.google.com/group/webvelocity?hl=en. |
Re: Saving Code (not publishing): How?
|
|
I'm very glad we have an answer that can keep you going but it disturbs
me that sqlite wasn't working. We'll have to look in to this some more. At least now we know what the error looked like for you, we'll be able to recognize it more easily. Michael On 4/17/10 8:37 AM, Hunter wrote: > James, > > John McKeon suggested using a different database for the repository. > I took hissuggestion to go away from the defaul sqlite and use a > Postgresql database as a respository (I thought this might be less > desireable and also didn't want whatever was causing the sqlite issue > to cause other issues down the line if I didn't solve it). It works! I > can actually start working in Smalltalk! > > On Apr 11, 10:38 am, James Robertson<[hidden email]> wrote: > >> well, you could fire up vwnc, and load the SQLlite driver, and see if it works >> >> On Apr 11, 2010, at 10:51 AM, Hunter wrote: >> >> >> >> >>> Just tried that and shutdown Webvelocity, relaunched Webvelocity, >>> defined database, mapped some classes - tried to publish: same error. >>> Seems sqlite isn't installed properly. Is there a way to test that >>> independent of Webvelocity? >>> >> >>> On Apr 11, 1:10 am, James Robertson<[hidden email]> wrote: >>> >>>> try putting it into Windows\system32 >>>> >> >>>> On Apr 10, 2010, at 11:18 PM, Hunter wrote: >>>> >> >>>>> Still working on this issue. I suspect it is related to possibly not >>>>> finding sqlite. When I attempt to publish, the following error is >>>>> displayed: >>>>> ‘There is no connection a database’ >>>>> OS: >>>>> Microsoft Windows Vista Home Premium Edition (x86 64-bit) Service Pack >>>>> 1 >>>>> Database Configuration: >>>>> Platform: PostgreSQL >>>>> Mappings: Schema1 >>>>> Host: localhost >>>>> Port: 5432 >>>>> Database: SICTEST >>>>> Schema: public >>>>> Username: postgres >>>>> Repository: >>>>> Name: Personal >>>>> Platform: SQLite 3 >>>>> Database: personal.db >>>>> >> >>>>> The only sqlite dll I could find was on my backup drive, so I copied >>>>> that file (sqlite3.dll 254 KB dated May 14, 2009, 6:04:00 AM ) >>>>> to C:\Program Files (x86)\Common Files. I added this to the path - >>>>> still no luck. Suggestions? >>>>> >> >>>>> On Mar 29, 12:26 am, "Mark D. Roberts"<[hidden email]> wrote: >>>>> >>>>>> On 3/29/2010 1:05 PM, Hunter wrote: >>>>>> >> >>>>>>> I'm just trying >>>>>>> 'save' my code (methods, classes, etc), but get the 'There is no >>>>>>> connection to a database' error and the suggestions I've received so >>>>>>> far don't seem to foot to something I can do specifically. I've >>>>>>> createda PostgreSQL database, complete with data. Supposedly my >>>>>>> database configuration works, the 'test login' works. Then I generated >>>>>>> (map) just a few classes. I want to save this, and future work too. My >>>>>>> exact steps are: 'Open Browser', click on my loaded application >>>>>>> 'ShawInvestmentCompany', select Actions\Publish, click OK. Form this I >>>>>>> receive 'There is no connection a database'. >>>>>>> >> >>>>>> Maybe you've already checked this over, but just to make sure... >>>>>> >> >>>>>> When you open the "Repositories" menu on the main page, what's selected? >>>>>> "Personal"? When you select "edit" for the currently selected >>>>>> repository, what are the connection settings in the "Edit Repository" >>>>>> dialog? >>>>>> >> >>>>>> In WebVelocity 1.0, the code for your application and its data are >>>>>> stored in distinct databases. The application code that you publish goes >>>>>> into a repository, and this is set using the "Repositories" menu on the >>>>>> main page. By default, WebVelocity uses a SQLite database called >>>>>> "Personal", and this should just be configured and ready to go when you >>>>>> launch. That is, SQLite is bundled with WebVelocity and no manual >>>>>> configuration is necessary, unless you want to save your code in a >>>>>> different repository. If you changed this setting to a different >>>>>> database, or the configuration is messed up somehow, then you may need >>>>>> to change it back. You can also create new code repositories using the >>>>>> "New" menu. >>>>>> >> >>>>>> Your application data, on the other hand, goes into a separate database >>>>>> that is configured from the "Database" menu in the Application Editor. >>>>>> It sounds like you have that configured correctly for your application, >>>>>> but perhaps somewhere along the line the repository that you have >>>>>> selected for code storage got confused somehow. >>>>>> >> >>>>>> So, I'd say double check that first. >>>>>> >> >>>>>> Regards, >>>>>> >> >>>>>> M. Roberts >>>>>> Cincom Systems, Inc. >>>>>> >> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups "WebVelocity" group. >>>>> To post to this group, send email to [hidden email]. >>>>> To unsubscribe from this group, send email to [hidden email]. >>>>> For more options, visit this group athttp://groups.google.com/group/webvelocity?hl=en.-Hide quoted text - >>>>> >> >>>> - Show quoted text - >>>> >> >>> -- >>> You received this message because you are subscribed to the Google Groups "WebVelocity" group. >>> To post to this group, send email to [hidden email]. >>> To unsubscribe from this group, send email to [hidden email]. >>> For more options, visit this group athttp://groups.google.com/group/webvelocity?hl=en.- Hide quoted text - >>> >> - Show quoted text - >> > -- You received this message because you are subscribed to the Google Groups "WebVelocity" group. To post to this group, send email to [hidden email]. To unsubscribe from this group, send email to [hidden email]. For more options, visit this group at http://groups.google.com/group/webvelocity?hl=en. |
Re: Saving Code (not publishing): How?
|
|
For what it's worth, using my VPS (Win2003 Server 64-bit virtual machine), I am able to:
1) Attempt to connect to the personal repository configured to use SQLite3, and get the error: External Object not found 2) Copy the sqlite3.dll to the WINDOWS/SysWOW64 directory 3) Connect to the sqlite3 configured repository and publish without error I am sad to admit, I probably went through all this sometime back when I first got the VPS but never reported anything. I have been using a Postgres repository for some time so I probably forgot about the issue, and frankly, probably figured it was something I caused as I think I just copied everything up to the server, including code parceled out to disk, etc etc. Anyway, I hope you find this useful John On Sun, Apr 18, 2010 at 3:49 PM, Michael Lucas-Smith <[hidden email]> wrote: I'm very glad we have an answer that can keep you going but it disturbs me that sqlite wasn't working. We'll have to look in to this some more. At least now we know what the error looked like for you, we'll be able to recognize it more easily. -- http://john-mckeon.us/seaside -- You received this message because you are subscribed to the Google Groups "WebVelocity" group. To post to this group, send email to [hidden email]. To unsubscribe from this group, send email to [hidden email]. For more options, visit this group at http://groups.google.com/group/webvelocity?hl=en. |
«
Return to WebVelocity
|
1 view|%1 views
| Free forum by Nabble | Edit this page |